/*
 Navicat Premium Data Transfer

 Source Server         : 刘于
 Source Server Type    : MySQL
 Source Server Version : 80020 (8.0.20)
 Source Host           : localhost:3306
 Source Schema         : onlinecode

 Target Server Type    : MySQL
 Target Server Version : 80020 (8.0.20)
 File Encoding         : 65001

 Date: 15/02/2023 14:53:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for architectures
-- ----------------------------
DROP TABLE IF EXISTS `architectures`;
CREATE TABLE `architectures` (
  `architectures_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `architectures_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `parent_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `view_authority` varchar(10000) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`architectures_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of architectures
-- ----------------------------
BEGIN;
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('0lksq-r4il1o', '中原市场部', 'dkiogb-wusokw', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('1h5oxak-uo442', '豫北市场部', 'dkiogb-wusokw', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('25fp-pknhx', '豫鲁市场部', 'dkiogb-wusokw', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('47a6ld-dx0q5m', '专业讲师', 'uuhvv-p2xigi', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('4tuauk-mu7xmn', '财务部', '0', '[\"Home\",\"EducationalMajors\",\"EducationalMajorsDetail\",\"Questions\",\"AcademicRoom\",\"EnterpriseArchitectures\",\"AcademicClass\",\"EducationalStudent\",\"AcademicClassDetail\",\"EducationalPaper\",\"EducationalPaperCreate\"]');
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('6qxij-jepot', '学管部', 'wd0r17-z498hh', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('aqfiqt-y9regf', '豫南市场部', 'dkiogb-wusokw', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('b4ishm-er8lm', '网络部', 'dkiogb-wusokw', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('cyqgig-olwrj8', '豫冀市场部', 'dkiogb-wusokw', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('dkiogb-wusokw', '市场部', '0', '[\"Home\",\"AcademicRoom\"]');
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('gorhwb-zxybsg', '测试1', 'vgensf-jtwrro', '[\"EducationalMajors\",\"Questions\",\"EducationalMajorsDetail\",\"AcademicRoom\"]');
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('lb14l3g-ipq558', '测试3', 'vgensf-jtwrro', '[\"EducationalMajors\",\"EducationalMajorsDetail\",\"Questions\",\"EducationalStudent\",\"EducationalPaper\",\"EducationalPaperCreate\",\"AcademicRoom\",\"Home\",\"AcademicClass\",\"AcademicClassDetail\",\"EnterpriseEmployee\",\"EnterpriseRole\",\"EnterpriseArchitectures\"]');
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('mjv3rn-rj0xf9', '豫晋市场部', 'dkiogb-wusokw', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('nn0w15-vtyycc', '就业指导', 'uuhvv-p2xigi', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('qnvlk-i3grq', '测试2', 'vgensf-jtwrro', '[\"EnterpriseArchitectures\",\"EnterpriseRole\",\"EducationalMajors\",\"EducationalMajorsDetail\",\"Home\"]');
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('sy56rr-kwb4qf', '文化课讲师', 'uuhvv-p2xigi', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('uuhvv-p2xigi', '讲师部', 'wd0r17-z498hh', '[1, 2, 3]');
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('vgensf-jtwrro', '测试部门1', '0', NULL);
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('wd0r17-z498hh', '教学部', '0', '[\"Home\",\"EducationalMajors\",\"EducationalMajorsDetail\",\"AcademicRoom\",\"AcademicClass\",\"AcademicClassDetail\",\"Questions\",\"EducationalStudent\",\"EducationalPaper\",\"EducationalPaperCreate\",\"EnterpriseArchitectures\",\"EnterpriseRole\",\"EnterpriseEmployee\"]');
INSERT INTO `architectures` (`architectures_id`, `architectures_name`, `parent_id`, `view_authority`) VALUES ('yacyql-yor732', '豫鄂市场部', 'dkiogb-wusokw', NULL);
COMMIT;

-- ----------------------------
-- Table structure for class
-- ----------------------------
DROP TABLE IF EXISTS `class`;
CREATE TABLE `class` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '班级名称',
  `room_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '教室ID',
  `teacher_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '讲师ID',
  `subject_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '课程ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `students` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '学生',
  `status` enum('1','2','3') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '1' COMMENT '状态',
  `majors_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '专业ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of class
-- ----------------------------
BEGIN;
INSERT INTO `class` (`id`, `class_name`, `room_id`, `teacher_id`, `subject_id`, `create_time`, `students`, `status`, `majors_id`) VALUES ('4kacdh-el83e', '2204', 'yq0dij-f3e74tn', 'snbjk-ooxebe', '0lqmqq-48xb3l', '2022-04-25 20:15:31', NULL, '1', 'jc1ua4-rufh2u');
INSERT INTO `class` (`id`, `class_name`, `room_id`, `teacher_id`, `subject_id`, `create_time`, `students`, `status`, `majors_id`) VALUES ('h4jca-20wii', '2204', '3mvt2-k1muyg', 'mij23n-ngswr', 'l97f4-18r2wc', '2022-05-13 15:42:59', NULL, '1', 'ldut5c-f8jisq');
COMMIT;

-- ----------------------------
-- Table structure for identity
-- ----------------------------
DROP TABLE IF EXISTS `identity`;
CREATE TABLE `identity` (
  `identity_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `identity_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`identity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of identity
-- ----------------------------
BEGIN;
INSERT INTO `identity` (`identity_id`, `identity_text`) VALUES ('63no9p-8y0k4', '管理员');
INSERT INTO `identity` (`identity_id`, `identity_text`) VALUES ('omeh5a-ycl52', '测试');
INSERT INTO `identity` (`identity_id`, `identity_text`) VALUES ('ozogqa-bhqz9', '新的');
INSERT INTO `identity` (`identity_id`, `identity_text`) VALUES ('uf81yn-hv8uvv', '出题者');
INSERT INTO `identity` (`identity_id`, `identity_text`) VALUES ('zi0gu7-v7dy08', '浏览者');
COMMIT;

-- ----------------------------
-- Table structure for identity_view_authority_relation
-- ----------------------------
DROP TABLE IF EXISTS `identity_view_authority_relation`;
CREATE TABLE `identity_view_authority_relation` (
  `identity_view_authority_relation_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `architectures_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `view_authority_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`identity_view_authority_relation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of identity_view_authority_relation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for majors
-- ----------------------------
DROP TABLE IF EXISTS `majors`;
CREATE TABLE `majors` (
  `majors_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `remark` varchar(10000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '课程简介',
  `duration` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '时长',
  `unit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '时长单位',
  PRIMARY KEY (`majors_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of majors
-- ----------------------------
BEGIN;
INSERT INTO `majors` (`majors_id`, `name`, `create_time`, `price`, `remark`, `duration`, `unit`) VALUES ('ldut5c-f8jisq', 'Web前端', '2022-05-07 11:50:00', 24800.00, 'WEB前端开发工程师在软件的开发过程中担任的是软件界面的开发工作，需要在工作中协调UI设计师、后端工程师共同实现一个网络应用的开发，主要的工作任务就是实现网站页面或程序的界面美化、交互体验的一个职位，比美工懂技术，比技术懂交互，是最贴近用户的工程师，是目前就业市场上竞争压力最小的，学习难度最低的，薪资水平也一直保持在10000-20000左右的一个开发岗位。', '7', '月');
COMMIT;

-- ----------------------------
-- Table structure for outline
-- ----------------------------
DROP TABLE IF EXISTS `outline`;
CREATE TABLE `outline` (
  `outline_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `outline_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `subject_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `parent_id` varchar(0) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`outline_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of outline
-- ----------------------------
BEGIN;
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('04toz8-tbo95j', '项目练习', 20, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('0gbvf-o45cg', 'Vue路由（下）', 18, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('1f6wjg-jjr76e', '自定义指令', 16, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('1gsmgo-fn518h', '综合实战', 10, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('1ixvj7-gp6y9c', 'Node构建CLI', 8, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('3dfx3b-r4z91', '网页布局实战', 8, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('3eih5c-01r2', 'Canvas绘制基础1', 11, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('3m91l8-d09xlh', 'HTML5入门', 16, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('3obixn-s0ih8', 'HTML基础语法与标签', 2, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('4gdaxk-hzlptd', '正则表达式', 18, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('4ifad-gzhjp', '网页实战1', 12, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('4mr4iw-shjxx', '运算符二', 5, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('4vkt8e-boo1ln', 'CSS3入门', 19, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('5f4tga-b81s2j', 'CSS3入门', 18, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('61ohv-bynohf', '面向对象实战1', 8, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('642kx5-ly0ome', '移动网站开发4', 20, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('6na3d-ivjgl', 'Canvas绘制基础2', 12, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('6no8ss-tzzff4', 'DOM对象模型', 14, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('6q4gom-63a43l', '网页实战练习', 14, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('6wf1n8-h5h38', 'CSS3新增选择器', 20, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('7076k5-gyk5k', 'ES6新增扩展3', 4, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('70vhk8-e3nqtw', '模块化应用', 17, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('7537of-fvprd', 'Vue初识', 9, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('75j98y-mwwhpj', '面向对象实战4', 11, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('7cty-0vefjr', '动态组件', 13, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('7eu4em-4sphk7', '三大赛', 2, '8ogfam-pr7z4g', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('7mt8x-n9q7gq', '项目练习', 21, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('7mvnam-u1g48', 'ES6入门', 1, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('7tt3bq-wmu87a', '啊啥大事的', 1, 'c90kq-89zq4m', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('876g8h-jvsins', '网页布局实战', 8, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('8gy2bl-b7dyx', '尺寸位置属性', 17, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('8okufw-pv48p9', '表单元素+表单样式', 9, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('8sb6d-vp4is', '过渡效果', 15, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('akzacq-r4yzg', 'JQuery原理实践', 5, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('baudex-pthbvk', 'Vue单文件组件', 11, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('bb1htm-ac88ol', '面向对象基本概念', 1, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('bx74ia-dh4nxa', 'gulp', 16, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('bx9ln-szgfs', '尺寸位置属性', 3, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('c2b6zh-64uow', '新增表单元素', 17, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('cz6d0s-t1zb1h', '网页实战3', 14, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('d0r3bo-jb5h4j', '网页的兼容处理', 11, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('d460ou-mdjpk', '表单元素+表单样式', 9, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('d75w5r-akd1fu', '什么是JavaScript', 1, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('duta6a-hvfhs6', 'CSS3新增选择器', 20, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('eb2xrc-iigjbd', 'CSS3入门', 18, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('eovbd-0m5j4', '综合案例', 20, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('fe9f2l-dd2c4h', '综合案例', 21, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('fwoel9-onj94w', 'H5新增API及canvas', 10, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('gp05cr-srt60a', '背景与边框', 6, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('guealk-oo9xj', '网页实战2', 13, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('h9zl8k-57sd5', '变量与数据类型', 2, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('hdxrdl-62ml09', 'ES6新增扩展1', 2, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('hggm1-bze2q', 'Sass', 1, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('hsqit-xtp2c', '字符串', 13, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('i7td8g-x220xd', 'css3样式', 15, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('is5tug-3clgw', 'DOM文档对象模型', 2, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('jdn5z-x6m0gq', '语句', 6, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('jkm78a-avoxq', 'HTML5入门', 16, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('jmj5y-our01h', '综合案例', 19, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('josyu-juhinq', '移动网站开发3', 19, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('k0pmoh-lpfv0k', 'CSS文本样式', 5, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('kijuil-1pz6cr', 'BOM', 18, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('kohzdp5-vpeib9', '组件通讯', 12, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('kpl3x-stoj3', 'CSS动画', 5, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('kt7l-ihcoc', '拖拽', 6, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('l4brr-5owuhn', '面向对象实战3', 10, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('lgowv4-wqfhb5', 'CSS样式基础', 3, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('lldpu-511ho', 'CSS样式基础', 3, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('mcifbl-gcpdlb', 'Web Storage', 8, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('mk1093-7rw2kp', '数组', 12, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('msqu5h-6zc5sc', 'Canvas绘制基础4', 14, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('mvs24u-nu38en', '数据类型的转换', 3, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('ngl2cv-xixnj', 'Canvas绘制基础3', 13, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('o4ngh-5n87t', '运算符一', 4, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('ol164k-1quq7', '浮动与定位', 7, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('p211k2-3qc10q', '项目练习', 19, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('po82mj-8zve9i', '滑屏应用', 7, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('pph59-ugaa19', 'ES6新增扩展2', 3, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('pr0w3r-zhy1d', '前端入门导入', 1, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('puv749-kzeytd', '得到的', 1, '8ogfam-pr7z4g', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('pyg7sf-91pi9', '啊啥大事', 3, '8ogfam-pr7z4g', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('q12raf-id2br', '响应式', 3, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('q7y3ic-cza08l', '前端入门导入', 1, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('q8yvkm-310gta', '综合实战', 10, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('qd3sef-4nzs68', 'AJAX', 15, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('qnrjed-o2rmgl', 'JQuery概念引入', 4, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('qybc4-5hr0uh', 'HTML5基础语法与标签', 2, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('rgt3gp-l20htn', 'Node基础-npm', 5, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('s2oeh-7apuf', '内置组件', 14, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('s36avj9-jlhn0r', 'sadasd', 2, 'qdd9un-dnq379', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('sqj7xl-f7kvuj', 'CSS文本样式', 5, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('suzuo5-gay5sf', '函数', 9, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('tkns3i-mjrriq', '多媒体（audio video）', 9, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('tn52hm-0ckwnf', '对象', 11, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('tzv0tb-mvhs5b', 'asdasdasd', 3, 'qdd9un-dnq379', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('u485th-6jvh5k', 'asdasd', 1, '90q5eb-yd165', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('ucuj2-2c2tnr', '新增表单元素', 17, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('v8qci2-wzzsr', 'Vue路由（上）', 17, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('vbubhg-1x09uq', 'CSS其他常用样式', 12, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('vdqzo-4tvyuq', 'CSS其他常用样式', 12, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('vdtndl-qupbek', '移动网站开发2', 18, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('vidwdb-jww87b', '网页实战练习', 15, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('vq6tx9-47xavu', '网页实战练习', 13, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wd5gdh-i94gp', '动态页面布局的综合运用', 4, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wdans-2kfepr', '浮动与定位', 7, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('win1w6-p4z55', '瀑布流效果实现', 16, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wjxsu-0oe7mk', '函数封装', 10, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wlkdj-y5abdf', 'CSS盒模型', 4, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wlzsba-kpiwr', '网页实战练习', 13, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wpcpql-csd3aj', 'CSS3入门', 19, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wuz0vf-gxboo', 'Node基础-内置模块', 7, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wwlmor-9bhkif', 'asdasd', 1, 'qdd9un-dnq379', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('wzkp1-n9op39', '面向对象实战2', 9, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('x3bdv-lnyzcb', 'CSS动画案例', 6, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('xlmzki-q9n5y', '移动网站开发1', 17, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('y2fmzh-y6tl6', '页面滚动相关', 7, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('yhh7j-ijeic7', '事件', 16, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('yjou9-fubybj', '弹性盒布局', 2, 'c3g1lr-k8uczbl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('ym9f4d-7xnc6o', 'CSS盒模型', 4, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('ysq6l-al29cm', '网页实战练习', 15, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('yzu6ag-ppsocq', 'DOM节点操作', 15, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('z5wlea-u84hg6', '网页实战练习', 14, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('zdn2x-xrniz', '循环语句一', 7, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('zhnoz-loz3a', '整站开发', 19, 'thz0jd-8bt3xl', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('zo62tf-9sd22', '循环语句二', 8, 'l97f4-18r2wc', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('zong1f-73tjzn', '网页的兼容处理', 11, '0lqmqq-48xb3l', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('zp572-c8k8ow', '背景与边框', 6, 'c2z4r7-5k8b0o', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('zpfydq-jw051c', 'Node基础-模块机制', 6, '78d06h-6t7va8', NULL);
INSERT INTO `outline` (`outline_id`, `outline_title`, `order_id`, `subject_id`, `parent_id`) VALUES ('zr6tqi-oq7ulq', '实例和组件', 10, '78d06h-6t7va8', NULL);
COMMIT;

-- ----------------------------
-- Table structure for paper
-- ----------------------------
DROP TABLE IF EXISTS `paper`;
CREATE TABLE `paper` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '试卷id',
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '试卷标题',
  `questions` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '试卷内容',
  `class_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '考试班级',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `students` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '考试学生',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `outline_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `majors_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of paper
-- ----------------------------
BEGIN;
INSERT INTO `paper` (`id`, `title`, `questions`, `class_id`, `start_time`, `end_time`, `students`, `create_time`, `outline_id`, `majors_id`, `subject_id`) VALUES ('lrkqck-9noa7k', '2021年9月项目实战周考一', '[{\"id\":\"qp1r5-lctq0s\",\"score\":2},{\"id\":\"qp1r5-lctq0s\",\"score\":2},{\"id\":\"qp1r5-lctq0s\",\"score\":2},{\"id\":\"qp1r5-lctq0s\",\"score\":2},{\"id\":\"qp1r5-lctq0s\",\"score\":2},{\"id\":\"qp1r5-lctq0s\",\"score\":2}]', 'f3eqqp-hbf66', '2021-09-25 10:00:00', '2021-09-25 12:24:57', '[\"f3eqqp-hbf66\",\"f3eqqp-hbf66\",\"f3eqqp-hbf66\",\"f3eqqp-hbf66\",\"f3eqqp-hbf66\"]', NULL, NULL, NULL, NULL);
INSERT INTO `paper` (`id`, `title`, `questions`, `class_id`, `start_time`, `end_time`, `students`, `create_time`, `outline_id`, `majors_id`, `subject_id`) VALUES ('tdy5rj-bcma6v', '2021年9月项目实战周考二', '[{\"id\":\"qp1r5-lctq0s\",\"score\":2},{\"id\":\"w56oam-92lco5\",\"score\":2}]', 'f3eqqp-hbf66', '2021-09-25 10:00:00', '2021-09-25 12:00:00', '[\"f3eqqp-hbf66\",\"f3eqqp-hbf66\",\"f3eqqp-hbf66\",\"f3eqqp-hbf66\",\"f3eqqp-hbf66\"]', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for question
-- ----------------------------
DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '题目ID',
  `question_type_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '类型ID',
  `quiz` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `tagsId` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '标签',
  `userId` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户Id',
  `createdAt` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `modifiedAt` date DEFAULT NULL COMMENT '修改时间',
  `numUsed` int DEFAULT NULL COMMENT '出题次数',
  `difficulty` int DEFAULT NULL COMMENT '难度',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '内容',
  `content` varchar(10000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '题目',
  `outline_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '课程ID',
  `majors_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of question
-- ----------------------------
BEGIN;
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('5ifme-l9ztx', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:30', NULL, 0, 1, '5ifme-l9ztx.json', '下面标签中默认属于行内元素的是', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('741jw-hx7a2e', 'w06o1o-g8hy1x', NULL, '[\"naa6sj-t36jwg\"]', '', '2022-05-23 23:16:32', NULL, 0, 1, '741jw-hx7a2e.json', '下列哪个样式定义后,内联(非块状)元素可以定义宽度和高度', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('7kdbck-f4tduj', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:33', NULL, 0, 2, '7kdbck-f4tduj.json', '为同一个文件添加多种文件格式的原因是什么 ？\n```\n<source src=\"html_5.mp4\" type=\"video/mp4\">\n<source src=\"html_5.ogv\" type=\"video/ogg\">\n```', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('8mh3yi-8qmmx', 'w06o1o-g8hy1x', NULL, '[\"uac9wq-asdc78\"]', '', '2022-05-23 23:16:34', NULL, 0, 1, '8mh3yi-8qmmx.json', '下列哪个操作是W3C标准定义的阻止事件向父容器传递：', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('9bk8in-39c0lap', 'w06o1o-g8hy1x', NULL, NULL, '', '2022-05-04 00:00:00', NULL, 0, 4, '9bk8in-39c0lap.json', '常见的块元素是那个', 'qybc4-5hr0uh', 'e05agh-aray3', '0lqmqq-48xb3l');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('fiedzi-d31r5', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:36', NULL, 0, 1, 'fiedzi-d31r5.json', '哪个属性将循环播放嵌入到 audio 元素中的音频？', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('hag5g-20c15', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:37', NULL, 0, 1, 'hag5g-20c15.json', '以下哪个是正确的 HTML5 DOCTYPE声明：', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('hez3i8-4i0cc', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:37', NULL, 0, 1, 'hez3i8-4i0cc.json', '以下不属于空元素（void elements）的是：', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('il8j8-svq52e', 'w06o1o-g8hy1x', NULL, NULL, '', '2023-02-15 14:32:24', NULL, NULL, 3, 'il8j8-svq52e.json', 'asdasdasd', 'pr0w3r-zhy1d', 'ldut5c-f8jisq', 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('juiyg7-cyeei', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:38', NULL, 0, 1, 'juiyg7-cyeei.json', '下列哪个不属于HTML input元素种类：', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('n144ax-fxntgd', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\",\"bveqpa-5tn3zy\"]', '', '2022-05-23 23:16:39', NULL, 0, 2, 'n144ax-fxntgd.json', '测试题目', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('pd7lzk-a1wuy8', 'w06o1o-g8hy1x', NULL, NULL, '', '2022-05-23 23:16:40', NULL, 0, 3, 'pd7lzk-a1wuy8.json', 'HTML的标签来源是什么？', NULL, NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('pr98y-4392cm', 'w06o1o-g8hy1x', NULL, '[\"en72u-4s3ad\",\"naa6sj-t36jwg\"]', '', '2022-05-23 23:16:41', NULL, 0, 5, 'pr98y-4392cm.json', 'sadasdasdasd', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('rkvhll-15r5h', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:42', NULL, 0, 1, 'rkvhll-15r5h.json', '下述可正确注释html代码的有？', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('ujvqxd-nddmhy', 'w06o1o-g8hy1x', NULL, '[\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:44', NULL, 0, 1, 'ujvqxd-nddmhy.json', 'img标签中的alt属性的作用是', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
INSERT INTO `question` (`id`, `question_type_id`, `quiz`, `tagsId`, `userId`, `createdAt`, `modifiedAt`, `numUsed`, `difficulty`, `path`, `content`, `outline_id`, `majors_id`, `subject_id`) VALUES ('yuur0h-1ad29j', '7iuhwq-tq4fwb', NULL, '[\"uac9wq-asdc78\",\"123ass-x0jys1h\"]', '', '2022-05-23 23:16:45', NULL, 0, 2, 'yuur0h-1ad29j.json', 'Html5重新提供了在客户端保存数据的功能Web Storage,分别是？（ ）', 'q7y3ic-cza08l', NULL, 'c2z4r7-5k8b0o');
COMMIT;

-- ----------------------------
-- Table structure for question_tag
-- ----------------------------
DROP TABLE IF EXISTS `question_tag`;
CREATE TABLE `question_tag` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `text` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of question_tag
-- ----------------------------
BEGIN;
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('11kkw9-vt8dxb', '项目开发', '#383333');
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('123ass-x0jys1h', 'Html', '#00ff00');
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('bveqpa-5tn3zy', 'React', '#ff0000');
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('e0b0l-41r0kl', 'es6', '#d9dd13');
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('en72u-4s3ad', 'Vue', '#ff0000');
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('ikp48v-3uwhlt', '小程序', '#1ca512');
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('naa6sj-t36jwg', 'Css', '#ff0000');
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('qpxmpg-uby6cj', 'webpack', '#41cc05');
INSERT INTO `question_tag` (`id`, `text`, `color`) VALUES ('uac9wq-asdc78', 'JavaScript', '#ff0000');
COMMIT;

-- ----------------------------
-- Table structure for question_type
-- ----------------------------
DROP TABLE IF EXISTS `question_type`;
CREATE TABLE `question_type` (
  `question_type_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `question_type_text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`question_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of question_type
-- ----------------------------
BEGIN;
INSERT INTO `question_type` (`question_type_id`, `question_type_text`) VALUES ('1l17vs-b9f3f', '项目题');
INSERT INTO `question_type` (`question_type_id`, `question_type_text`) VALUES ('7iuhwq-tq4fwb', '多选题');
INSERT INTO `question_type` (`question_type_id`, `question_type_text`) VALUES ('87kgip-7ejy', '解答题');
INSERT INTO `question_type` (`question_type_id`, `question_type_text`) VALUES ('f06o1o-j8hy1x', '判断题');
INSERT INTO `question_type` (`question_type_id`, `question_type_text`) VALUES ('kq3c3-k7ywzg', '填空题');
INSERT INTO `question_type` (`question_type_id`, `question_type_text`) VALUES ('w06o1o-g8hy1x', '单选题');
COMMIT;

-- ----------------------------
-- Table structure for result
-- ----------------------------
DROP TABLE IF EXISTS `result`;
CREATE TABLE `result` (
  `id` int NOT NULL AUTO_INCREMENT,
  `paper_id` int DEFAULT NULL,
  `student_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `score` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `result` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of result
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room` (
  `room_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `room_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `floor` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('1001','1002','1003','1004') COLLATE utf8_unicode_ci DEFAULT '1001',
  `majors_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of room
-- ----------------------------
BEGIN;
INSERT INTO `room` (`room_id`, `room_num`, `floor`, `type`, `majors_id`) VALUES ('3mvt2-k1muyg', '305', '2', '1002', NULL);
INSERT INTO `room` (`room_id`, `room_num`, `floor`, `type`, `majors_id`) VALUES ('5lz40s-jvno0u', '308', '2', '1001', NULL);
INSERT INTO `room` (`room_id`, `room_num`, `floor`, `type`, `majors_id`) VALUES ('a6s8rp-uv1phg', '309', '2', '1001', NULL);
INSERT INTO `room` (`room_id`, `room_num`, `floor`, `type`, `majors_id`) VALUES ('cd4xpa-0l2wsm', '306', '2', '1001', NULL);
INSERT INTO `room` (`room_id`, `room_num`, `floor`, `type`, `majors_id`) VALUES ('xolr0l-iz50a3', '307', '2', '1001', NULL);
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `student_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'id',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '姓名',
  `id_card` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '身份证号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '密码',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '手机号',
  `birthDate` date DEFAULT NULL COMMENT '生日',
  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '注释',
  `sex` enum('0','1') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '性别',
  `channel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '渠道',
  `create_time` datetime DEFAULT NULL COMMENT '报名时间',
  `entrance_time` datetime DEFAULT NULL COMMENT '入学时间',
  `highestEducation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '最高学历',
  `nation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '民族',
  `pofession` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '职业',
  `nativePlace` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '籍贯',
  `majors_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '专业ID',
  `subject_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '课程ID',
  `history` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '历史记录',
  `market_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '市场ID',
  `market_teacher_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '市场老师ID',
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '详细地址',
  `card_path` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '身份证图片',
  `status` enum('1','2','3','4','5','6','7') COLLATE utf8_unicode_ci DEFAULT '1' COMMENT '在校状态',
  PRIMARY KEY (`student_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for subject
-- ----------------------------
DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject` (
  `subject_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `subject_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `majors_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  PRIMARY KEY (`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of subject
-- ----------------------------
BEGIN;
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('0lqmqq-48xb3l', '结构样式', 'e05agh-aray3', 1);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('1owtcc-4w3mg', '啊啥大事的', 'e05agh-aray3', 3);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('3512jg-er38uv', '啊啥的', 'f8b1vp-93kbe', 2);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('3cxn5m-3zzxp', 'JavaScript', 'e05agh-aray3', 2);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('78d06h-6t7va8', '渐进式开发', 'ldut5c-f8jisq', 5);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('7jc8dx-rk9bf', '工程化开发', 'ldut5c-f8jisq', 7);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('8ogfam-pr7z4g', '打算', 'f8b1vp-93kbe', 1);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('90q5eb-yd165', 'asdasdasd', '6zxnao-1lvdbs', 2);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('9445dp-9qb3lq', '项目实战', 'e05agh-aray3', 3);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('bhdvch-rho5ic', '移动开发', 'e05agh-aray3', 4);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('c2z4r7-5k8b0o', '结构样式', 'ldut5c-f8jisq', 1);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('c3g1lr-k8uczbl', 'HTML5移动开发', 'ldut5c-f8jisq', 4);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('c90kq-89zq4m', '啊啥的', 'e05agh-aray3', 1);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('l97f4-18r2wc', 'JavaScript前端开发', 'ldut5c-f8jisq', 2);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('pontug-m38dem', '123123', 'e05agh-aray3', 2);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('qdd9un-dnq379', 'asdasdasd', '6zxnao-1lvdbs', 1);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('r5y9g-tsf2q', 'asdasdasda', '6zxnao-1lvdbs', 3);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('thz0jd-8bt3xl', '项目实战', 'ldut5c-f8jisq', 3);
INSERT INTO `subject` (`subject_id`, `subject_title`, `majors_id`, `order_id`) VALUES ('y6v4ru-qluiit', '组件化开发', 'ldut5c-f8jisq', 6);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '员工账号',
  `user_pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '账号密码',
  `id_card` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '身份证号',
  `sex` enum('0','1') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '性别',
  `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '手机号',
  `nation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '民族',
  `native_place` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '籍贯',
  `photo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '头像',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` enum('1','2','3') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '当前状态',
  `specialty` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '特长',
  `education` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '最高学历',
  `architectures_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '所属部门',
  `level` enum('1','2','3','4','5','6','7','8','9','10') CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '市场级别',
  `card_path` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '身份证照片',
  `bank_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '银行卡号',
  `bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '银行',
  `is_market` enum('0','1') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '是否是市场人员',
  `market_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '市场ID',
  `parent_user` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '上级老师',
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '姓名',
  `bank_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '银行卡姓名',
  `signup` int DEFAULT '0' COMMENT '报名人数',
  `entrance` int DEFAULT '0' COMMENT '入学人数',
  `dropout` int DEFAULT '0' COMMENT '退学人数',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('0plx1o-t37r5q', '13333719201', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '412932197303013942', '0', '13333719201', NULL, '411330', '[]', '2022-10-20 16:24:27', NULL, NULL, NULL, NULL, '4', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":640,\"height\":853,\"location\":\"wxfile://tmp_fc7aef5fc2604356861b8d66d4f01595ebaccd97771848ac.jpg\"},\"name\":\"tmp_fc7aef5fc2604356861b8d66d4f01595ebaccd97771848ac.jpg\",\"path\":\"wxfile://tmp_fc7aef5fc2604356861b8d66d4f01595ebaccd97771848ac.jpg\",\"size\":70028,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/35eca1f1-9295-4f32-8a60-ce3fae671a64.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/35eca1f1-9295-4f32-8a60-ce3fae671a64.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":1280,\"height\":1706,\"location\":\"wxfile://tmp_6a48fd849ff3720219627118b8b3c24522439c5ba37cff67.jpg\"},\"name\":\"tmp_6a48fd849ff3720219627118b8b3c24522439c5ba37cff67.jpg\",\"path\":\"wxfile://tmp_6a48fd849ff3720219627118b8b3c24522439c5ba37cff67.jpg\",\"size\":418532,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/3c272f75-84d7-43d2-99e1-5b0dd2ad7455.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/3c272f75-84d7-43d2-99e1-5b0dd2ad7455.jpg\"}]]', '无', NULL, '1', 'aqfiqt-y9regf', 'll50b-zh3ln', '铁宇芝', '无', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('1k4wgi-9rci4j', '17737165911', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '412901195110110515', '1', '17737165911', NULL, '411302', '[]', '2022-10-20 14:12:27', NULL, NULL, NULL, NULL, '1', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":640,\"height\":854,\"location\":\"wxfile://tmp_c834d0e9483a417ad24b858aad42110b1f8415c71973668e.jpg\"},\"name\":\"tmp_c834d0e9483a417ad24b858aad42110b1f8415c71973668e.jpg\",\"path\":\"wxfile://tmp_c834d0e9483a417ad24b858aad42110b1f8415c71973668e.jpg\",\"size\":43243,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/834d5abe-4673-4298-9499-4ee8261890d9.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/834d5abe-4673-4298-9499-4ee8261890d9.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":854,\"height\":640,\"location\":\"wxfile://tmp_9b38c2e44709308959b80c6f8ed81163913b4082667166a7.jpg\"},\"name\":\"tmp_9b38c2e44709308959b80c6f8ed81163913b4082667166a7.jpg\",\"path\":\"wxfile://tmp_9b38c2e44709308959b80c6f8ed81163913b4082667166a7.jpg\",\"size\":50742,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/38c83e29-0419-4425-bf30-73d892e908a2.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/38c83e29-0419-4425-bf30-73d892e908a2.jpg\"}]]', '无', NULL, '1', 'aqfiqt-y9regf', '26bjgz-cbnqhn', '舒松林', '无', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('1yjt5t-sisjhl', '15538427216', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '412925196802203419', '1', '15538427216', NULL, '411302', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":654,\"height\":1013,\"location\":\"wxfile://tmp_a47fa4f1f4cdf095391c3999a1a6a7ec32534f06dd052bae.jpg\"},\"name\":\"tmp_a47fa4f1f4cdf095391c3999a1a6a7ec32534f06dd052bae.jpg\",\"path\":\"wxfile://tmp_a47fa4f1f4cdf095391c3999a1a6a7ec32534f06dd052bae.jpg\",\"size\":159986,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/3aa5188f-4e3a-4e59-a7d5-0a23ac6cd77c.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/3aa5188f-4e3a-4e59-a7d5-0a23ac6cd77c.jpg\"}]', '2022-10-20 14:15:10', NULL, NULL, NULL, NULL, '1', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":1920,\"height\":909,\"location\":\"wxfile://tmp_816e18043f9d027ebb4addd923768b0c8178981bdca392d5.jpg\"},\"name\":\"tmp_816e18043f9d027ebb4addd923768b0c8178981bdca392d5.jpg\",\"path\":\"wxfile://tmp_816e18043f9d027ebb4addd923768b0c8178981bdca392d5.jpg\",\"size\":124009,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/01b84398-2534-447f-99d2-c0430870c88e.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/01b84398-2534-447f-99d2-c0430870c88e.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":909,\"height\":1920,\"location\":\"wxfile://tmp_041dfb8f991f0fbad41aea4047b743e90bbbfa819dee8dbe.jpg\"},\"name\":\"tmp_041dfb8f991f0fbad41aea4047b743e90bbbfa819dee8dbe.jpg\",\"path\":\"wxfile://tmp_041dfb8f991f0fbad41aea4047b743e90bbbfa819dee8dbe.jpg\",\"size\":144265,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/64d8d0d2-174d-47aa-bddc-b06490ee7aa5.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/64d8d0d2-174d-47aa-bddc-b06490ee7aa5.jpg\"}]]', '无', NULL, '1', 'aqfiqt-y9regf', '1k4wgi-9rci4j', '李玉民', '无', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('26bjgz-cbnqhn', '13333861878', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '12345678999', '0', '13333861878', '汉', '河南', '[{\"extname\":\"png\",\"fileType\":\"image\",\"image\":{\"width\":610,\"height\":325,\"location\":\"http://tmp/HpNtcGe62W85f0f9987a91c66aa00fba964d040b2afb.png\"},\"name\":\"HpNtcGe62W85f0f9987a91c66aa00fba964d040b2afb.png\",\"path\":\"http://tmp/HpNtcGe62W85f0f9987a91c66aa00fba964d040b2afb.png\",\"size\":104280,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/e5da00eb-6268-48ed-9dbd-2a1a108235cf.png\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/e5da00eb-6268-48ed-9dbd-2a1a108235cf.png\"}]', '2022-09-26 18:53:50', NULL, '', '本科', 'dkiogb-wusokw', '10', NULL, NULL, NULL, '1', 'dkiogb-wusokw', NULL, '刘创亚', NULL, 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('3aymbr-5nyao', '13683599383', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '2156127376123', '0', '13683599384', 'dwqe', 'wqeqwe', '', '2022-10-30 14:29:01', NULL, 'qweqwe', 'qweqwe', 'qnvlk-i3grq', NULL, NULL, NULL, NULL, NULL, 'qnvlk-i3grq', NULL, '测试3', NULL, 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('4u2psl-bvsm0c', '18637772226', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '411330198308161117', '1', '18637772226', NULL, '410104', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":480,\"height\":480,\"location\":\"wxfile://tmp_cb0bb91075dc72089102bb98eab7325e0ec8b3f1d6a68e86.jpg\"},\"name\":\"tmp_cb0bb91075dc72089102bb98eab7325e0ec8b3f1d6a68e86.jpg\",\"path\":\"wxfile://tmp_cb0bb91075dc72089102bb98eab7325e0ec8b3f1d6a68e86.jpg\",\"size\":38031,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/07cfa9ba-ea9d-495d-b5a4-305859410da9.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/07cfa9ba-ea9d-495d-b5a4-305859410da9.jpg\"}]', '2022-10-08 17:26:13', NULL, NULL, NULL, NULL, '9', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":960,\"height\":604,\"location\":\"wxfile://tmp_9b6b5475b958ae850c6a9d1ef0b823bf5af3bda092e51f1a.jpg\"},\"name\":\"tmp_9b6b5475b958ae850c6a9d1ef0b823bf5af3bda092e51f1a.jpg\",\"path\":\"wxfile://tmp_9b6b5475b958ae850c6a9d1ef0b823bf5af3bda092e51f1a.jpg\",\"size\":72051,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/25b56fbb-502e-4f48-abf1-96255082503b.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/25b56fbb-502e-4f48-abf1-96255082503b.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":960,\"height\":604,\"location\":\"wxfile://tmp_75f188ba5e6b6632baed3a3487104be56efea4739b834df6.jpg\"},\"name\":\"tmp_75f188ba5e6b6632baed3a3487104be56efea4739b834df6.jpg\",\"path\":\"wxfile://tmp_75f188ba5e6b6632baed3a3487104be56efea4739b834df6.jpg\",\"size\":72051,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/ddb2dafe-db14-452f-9a91-0fc432729a4e.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/ddb2dafe-db14-452f-9a91-0fc432729a4e.jpg\"}]]', '411330198308161117', NULL, '1', 'b4ishm-er8lm', 'snbjk-ooxebe', '黄雪锋', '黄锋', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('ebb2x-0dmofr', '18500047564', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '42142142', '1', '18500047564', '汉', '120103', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":480,\"height\":480,\"location\":\"wxfile://tmp_cb0bb91075dc72089102bb98eab7325e0ec8b3f1d6a68e86.jpg\"},\"name\":\"tmp_cb0bb91075dc72089102bb98eab7325e0ec8b3f1d6a68e86.jpg\",\"path\":\"wxfile://tmp_cb0bb91075dc72089102bb98eab7325e0ec8b3f1d6a68e86.jpg\",\"size\":38031,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/07cfa9ba-ea9d-495d-b5a4-305859410da9.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/07cfa9ba-ea9d-495d-b5a4-305859410da9.jpg\"}]', '2022-10-09 14:55:24', NULL, '', '本科', 'dkiogb-wusokw', '10', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":960,\"height\":604,\"location\":\"wxfile://tmp_9b6b5475b958ae850c6a9d1ef0b823bf5af3bda092e51f1a.jpg\"},\"name\":\"tmp_9b6b5475b958ae850c6a9d1ef0b823bf5af3bda092e51f1a.jpg\",\"path\":\"wxfile://tmp_9b6b5475b958ae850c6a9d1ef0b823bf5af3bda092e51f1a.jpg\",\"size\":72051,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/25b56fbb-502e-4f48-abf1-96255082503b.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/25b56fbb-502e-4f48-abf1-96255082503b.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":960,\"height\":604,\"location\":\"wxfile://tmp_75f188ba5e6b6632baed3a3487104be56efea4739b834df6.jpg\"},\"name\":\"tmp_75f188ba5e6b6632baed3a3487104be56efea4739b834df6.jpg\",\"path\":\"wxfile://tmp_75f188ba5e6b6632baed3a3487104be56efea4739b834df6.jpg\",\"size\":72051,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/ddb2dafe-db14-452f-9a91-0fc432729a4e.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/ddb2dafe-db14-452f-9a91-0fc432729a4e.jpg\"}]]', '411330198308161117', NULL, '1', 'dkiogb-wusokw', NULL, '胡均', '胡均', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('f8xl8b-yzsub', '17539533133', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '411121196308025581', '0', '17539533133', NULL, '411121', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":640,\"height\":853,\"location\":\"wxfile://tmp_1236848cba3e4c0e29efeba2cf58fc731c53a5866fcfc072.jpg\"},\"name\":\"tmp_1236848cba3e4c0e29efeba2cf58fc731c53a5866fcfc072.jpg\",\"path\":\"wxfile://tmp_1236848cba3e4c0e29efeba2cf58fc731c53a5866fcfc072.jpg\",\"size\":40949,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/1eff2a4c-0a99-4e92-a7ee-08ecc20b1dce.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/1eff2a4c-0a99-4e92-a7ee-08ecc20b1dce.jpg\"}]', '2022-10-20 15:01:55', NULL, NULL, NULL, NULL, '3', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":640,\"height\":853,\"location\":\"wxfile://tmp_a0f553fd6de387aefb513ab17cd7ba3c1adad21b9cb84850.jpg\"},\"name\":\"tmp_a0f553fd6de387aefb513ab17cd7ba3c1adad21b9cb84850.jpg\",\"path\":\"wxfile://tmp_a0f553fd6de387aefb513ab17cd7ba3c1adad21b9cb84850.jpg\",\"size\":92054,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/daab5878-6bfc-47e4-8b04-cefeb2b66d82.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/daab5878-6bfc-47e4-8b04-cefeb2b66d82.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":640,\"height\":853,\"location\":\"wxfile://tmp_4003917f3b48b44c22c550fc663d4435c496e21b10718122.jpg\"},\"name\":\"tmp_4003917f3b48b44c22c550fc663d4435c496e21b10718122.jpg\",\"path\":\"wxfile://tmp_4003917f3b48b44c22c550fc663d4435c496e21b10718122.jpg\",\"size\":99571,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/34768928-75fc-4e07-b1ff-f0ed3171ceb0.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/34768928-75fc-4e07-b1ff-f0ed3171ceb0.jpg\"}]]', '无', NULL, '1', 'aqfiqt-y9regf', 'fhqp1c-ej8gd', '周京霞', '无', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('fhqp1c-ej8gd', '13782390338', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '410426196202176514', '1', '13782390338', NULL, '411025', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":640,\"height\":853,\"location\":\"wxfile://tmp_4352663263cc563d81846eedb4907d7f835514743a0a1e9c.jpg\"},\"name\":\"tmp_4352663263cc563d81846eedb4907d7f835514743a0a1e9c.jpg\",\"path\":\"wxfile://tmp_4352663263cc563d81846eedb4907d7f835514743a0a1e9c.jpg\",\"size\":30177,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/2b38b7a8-c07a-4c8d-b892-00bbc75f4c41.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/2b38b7a8-c07a-4c8d-b892-00bbc75f4c41.jpg\"}]', '2022-10-20 15:56:47', NULL, NULL, NULL, NULL, '2', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":640,\"height\":853,\"location\":\"wxfile://tmp_a7a5e6fcbab175651eeb18622d27de000f7eb9ab849918db.jpg\"},\"name\":\"tmp_a7a5e6fcbab175651eeb18622d27de000f7eb9ab849918db.jpg\",\"path\":\"wxfile://tmp_a7a5e6fcbab175651eeb18622d27de000f7eb9ab849918db.jpg\",\"size\":39253,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/0206f006-368c-45a6-a827-7eddcf4f3d8d.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/0206f006-368c-45a6-a827-7eddcf4f3d8d.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":640,\"height\":853,\"location\":\"wxfile://tmp_3d6826df78a3afbc4cc4b552ac202232188c86d6db22de5d.jpg\"},\"name\":\"tmp_3d6826df78a3afbc4cc4b552ac202232188c86d6db22de5d.jpg\",\"path\":\"wxfile://tmp_3d6826df78a3afbc4cc4b552ac202232188c86d6db22de5d.jpg\",\"size\":55696,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/80cc7fff-9e23-4ac4-b3ee-138fd5bc1600.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/80cc7fff-9e23-4ac4-b3ee-138fd5bc1600.jpg\"}]]', '无', NULL, '1', 'aqfiqt-y9regf', '1yjt5t-sisjhl', '范法仓', '无', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('it9iu-s2x0n9', '13683599381', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '2156127376123', '0', '13683599382', 'dwqe', 'wqeqwe', '', '2022-10-30 14:28:25', NULL, 'qweqwe', 'qweqwe', 'gorhwb-zxybsg', NULL, NULL, NULL, NULL, NULL, 'gorhwb-zxybsg', NULL, '测试1', NULL, 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('ll50b-zh3ln', '18939206797', 'b62e8881a001439b5b5aeae7b0b7a0b9354ac48689975fdb4010687b1f9ca9e7', '41293219711103292X', '0', '18939206797', NULL, '411330', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":924,\"height\":1920,\"location\":\"wxfile://tmp_fe979967926571b91c62f1a32e50a53b361f471741b9bb50.jpg\"},\"name\":\"tmp_fe979967926571b91c62f1a32e50a53b361f471741b9bb50.jpg\",\"path\":\"wxfile://tmp_fe979967926571b91c62f1a32e50a53b361f471741b9bb50.jpg\",\"size\":192612,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/ddba5058-3e95-4d2c-8a7f-b5bd3af945ba.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/ddba5058-3e95-4d2c-8a7f-b5bd3af945ba.jpg\"}]', '2022-10-20 15:29:26', NULL, NULL, NULL, NULL, '3', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":1440,\"height\":693,\"location\":\"wxfile://tmp_0928d03b96d4bf23b40ebc9b51bdc102300e432ca03b066c.jpg\"},\"name\":\"tmp_0928d03b96d4bf23b40ebc9b51bdc102300e432ca03b066c.jpg\",\"path\":\"wxfile://tmp_0928d03b96d4bf23b40ebc9b51bdc102300e432ca03b066c.jpg\",\"size\":46304,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/c1026569-3666-4614-a1c5-87714a5cda15.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/c1026569-3666-4614-a1c5-87714a5cda15.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":693,\"height\":1440,\"location\":\"wxfile://tmp_e504cb5273eb192e94e521e8adc90765cfb6ebe83f3161af.jpg\"},\"name\":\"tmp_e504cb5273eb192e94e521e8adc90765cfb6ebe83f3161af.jpg\",\"path\":\"wxfile://tmp_e504cb5273eb192e94e521e8adc90765cfb6ebe83f3161af.jpg\",\"size\":73885,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/5870d00f-cf13-435f-99a0-693d1d46a6bb.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/5870d00f-cf13-435f-99a0-693d1d46a6bb.jpg\"}]]', '无', NULL, '1', 'aqfiqt-y9regf', '1yjt5t-sisjhl', '岳文香', '无', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('mn4ted-xjc8sp', '13683599380', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '14022419950915009X', '1', '13683599380', NULL, '140224', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":1280,\"height\":1790,\"location\":\"wxfile://tmp_788bf42c3dcb6e7e9063f6ebed0af49d.jpg\"},\"name\":\"tmp_788bf42c3dcb6e7e9063f6ebed0af49d.jpg\",\"path\":\"wxfile://tmp_788bf42c3dcb6e7e9063f6ebed0af49d.jpg\",\"size\":205448,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/572b37b6-2f18-4dac-b7bd-ea249b47bab0.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/572b37b6-2f18-4dac-b7bd-ea249b47bab0.jpg\"}]', '2022-09-30 00:55:45', NULL, NULL, NULL, NULL, '10', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":1035,\"height\":1840,\"location\":\"wxfile://tmp_9766829caed89205dc5fc9248002ff1f.jpg\"},\"name\":\"tmp_9766829caed89205dc5fc9248002ff1f.jpg\",\"path\":\"wxfile://tmp_9766829caed89205dc5fc9248002ff1f.jpg\",\"size\":408299,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/b8d14e3b-6aea-4aee-98cc-ac09d9058f0d.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/b8d14e3b-6aea-4aee-98cc-ac09d9058f0d.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":1080,\"height\":1920,\"location\":\"wxfile://tmp_e3cc51c428c54c664955a4fc278dcce7.jpg\"},\"name\":\"tmp_e3cc51c428c54c664955a4fc278dcce7.jpg\",\"path\":\"wxfile://tmp_e3cc51c428c54c664955a4fc278dcce7.jpg\",\"size\":471144,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/e2a17d4a-d267-49f7-93a9-5cb828d1b0f2.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/e2a17d4a-d267-49f7-93a9-5cb828d1b0f2.jpg\"}]]', '12838384894949472', NULL, '1', 'dkiogb-wusokw', '', '刘 于', '刘于', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('snbjk-ooxebe', 'liuyu3', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '134444444444444444', '1', '13683599380', NULL, '120103', '[{\"extname\":\"png\",\"fileType\":\"image\",\"image\":{\"width\":610,\"height\":325,\"location\":\"http://tmp/HpNtcGe62W85f0f9987a91c66aa00fba964d040b2afb.png\"},\"name\":\"HpNtcGe62W85f0f9987a91c66aa00fba964d040b2afb.png\",\"path\":\"http://tmp/HpNtcGe62W85f0f9987a91c66aa00fba964d040b2afb.png\",\"size\":104280,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/e5da00eb-6268-48ed-9dbd-2a1a108235cf.png\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/e5da00eb-6268-48ed-9dbd-2a1a108235cf.png\"}]', '2022-08-26 22:32:54', NULL, NULL, NULL, '4tuauk-mu7xmn', '4', '[[{\"extname\":\"png\",\"fileType\":\"image\",\"image\":{\"width\":610,\"height\":325,\"location\":\"http://tmp/PXzjsyVEATAQf0f9987a91c66aa00fba964d040b2afb.png\"},\"name\":\"PXzjsyVEATAQf0f9987a91c66aa00fba964d040b2afb.png\",\"path\":\"http://tmp/PXzjsyVEATAQf0f9987a91c66aa00fba964d040b2afb.png\",\"size\":104280,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/d773a867-95f4-4e20-ba31-cdb07ae01950.png\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/d773a867-95f4-4e20-ba31-cdb07ae01950.png\"}],[{\"extname\":\"png\",\"fileType\":\"image\",\"image\":{\"width\":610,\"height\":325,\"location\":\"http://tmp/6qI3O0T4sa13f0f9987a91c66aa00fba964d040b2afb.png\"},\"name\":\"6qI3O0T4sa13f0f9987a91c66aa00fba964d040b2afb.png\",\"path\":\"http://tmp/6qI3O0T4sa13f0f9987a91c66aa00fba964d040b2afb.png\",\"size\":104280,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/a64f8626-e5b3-4edb-b4e5-ac4fdf28fea3.png\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/a64f8626-e5b3-4edb-b4e5-ac4fdf28fea3.png\"}]]', '123123123123123123', NULL, '1', 'b4ishm-er8lm', '26bjgz-cbnqhn', '超级管理员', '刘于', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('tuc2so-9vua28', '15688173133', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '412932197905173644', '0', '15688173133', NULL, '411330', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":140,\"height\":180,\"location\":\"wxfile://tmp_dfa35362e6e93fb1f3ee7e65d8863588f43d2f5d91337215.jpg\"},\"name\":\"tmp_dfa35362e6e93fb1f3ee7e65d8863588f43d2f5d91337215.jpg\",\"path\":\"wxfile://tmp_dfa35362e6e93fb1f3ee7e65d8863588f43d2f5d91337215.jpg\",\"size\":17566,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/79fe0bcf-d565-41e5-9afc-7bce8983f810.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/79fe0bcf-d565-41e5-9afc-7bce8983f810.jpg\"}]', '2022-10-20 15:50:58', NULL, NULL, NULL, NULL, '5', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":854,\"height\":561,\"location\":\"wxfile://tmp_1df4f903d1ee8417e2de35c14a7d4d255f6b2180f3c1b0ab.jpg\"},\"name\":\"tmp_1df4f903d1ee8417e2de35c14a7d4d255f6b2180f3c1b0ab.jpg\",\"path\":\"wxfile://tmp_1df4f903d1ee8417e2de35c14a7d4d255f6b2180f3c1b0ab.jpg\",\"size\":27455,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/f5cb64c8-8c57-49dc-a5ea-da99943d306e.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/f5cb64c8-8c57-49dc-a5ea-da99943d306e.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":693,\"height\":1440,\"location\":\"wxfile://tmp_3fd3230097d4203b7f38c329af85b9ba8764df14a699596e.jpg\"},\"name\":\"tmp_3fd3230097d4203b7f38c329af85b9ba8764df14a699596e.jpg\",\"path\":\"wxfile://tmp_3fd3230097d4203b7f38c329af85b9ba8764df14a699596e.jpg\",\"size\":363550,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/a39c3667-c16a-4fc5-84b3-df38469aad2c.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/a39c3667-c16a-4fc5-84b3-df38469aad2c.jpg\"}]]', '无', NULL, '1', 'aqfiqt-y9regf', 'll50b-zh3ln', '舒春香', '无', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('tx599p-ofqsh', '13303977028', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '413029196309050428', '0', '13303977028', NULL, '411523', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":940,\"height\":940,\"location\":\"wxfile://tmp_e18c1a25be9b90e16c9e97c5f6a29c7d4cafd355b893b9ca.jpg\"},\"name\":\"tmp_e18c1a25be9b90e16c9e97c5f6a29c7d4cafd355b893b9ca.jpg\",\"path\":\"wxfile://tmp_e18c1a25be9b90e16c9e97c5f6a29c7d4cafd355b893b9ca.jpg\",\"size\":78476,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/d2b3166a-bdf7-4ed9-bbd3-87160b59e44c.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/d2b3166a-bdf7-4ed9-bbd3-87160b59e44c.jpg\"}]', '2022-10-20 14:45:02', NULL, NULL, NULL, NULL, '1', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":745,\"height\":519,\"location\":\"wxfile://tmp_8d224a7ed2fa4443e50b4c25cd583d550586ddca362d9a19.jpg\"},\"name\":\"tmp_8d224a7ed2fa4443e50b4c25cd583d550586ddca362d9a19.jpg\",\"path\":\"wxfile://tmp_8d224a7ed2fa4443e50b4c25cd583d550586ddca362d9a19.jpg\",\"size\":41278,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/da056989-d70f-498b-8978-13b80f62c4fc.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/da056989-d70f-498b-8978-13b80f62c4fc.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":746,\"height\":501,\"location\":\"wxfile://tmp_fa31178dfe265dd4f370b64e8a05a8fa1c774f81eda323fe.jpg\"},\"name\":\"tmp_fa31178dfe265dd4f370b64e8a05a8fa1c774f81eda323fe.jpg\",\"path\":\"wxfile://tmp_fa31178dfe265dd4f370b64e8a05a8fa1c774f81eda323fe.jpg\",\"size\":198637,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/4ed355e6-8bed-47e4-94e2-55326c76c0d9.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/4ed355e6-8bed-47e4-94e2-55326c76c0d9.jpg\"}]]', '无', NULL, '1', 'aqfiqt-y9regf', '1k4wgi-9rci4j', '潘 琼', '无', 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('waqmys-33ulm', '13683599382', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '2156127376123', '0', '13683599383', 'dwqe', 'wqeqwe', '', '2022-10-30 14:28:47', NULL, 'qweqwe', 'qweqwe', 'lb14l3g-ipq558', NULL, NULL, NULL, NULL, NULL, 'lb14l3g-ipq558', NULL, '测试2', NULL, 0, 0, 0);
INSERT INTO `user` (`user_id`, `user_name`, `user_pwd`, `id_card`, `sex`, `mobile`, `nation`, `native_place`, `photo`, `create_time`, `status`, `specialty`, `education`, `architectures_id`, `level`, `card_path`, `bank_number`, `bank`, `is_market`, `market_id`, `parent_user`, `nickname`, `bank_name`, `signup`, `entrance`, `dropout`) VALUES ('yf33so-vzppk4', '13683599324', '889216bbd7962ed4511407a96124abeeafe485811a00de6d188f818bd5a492ed', '14022419950915009X', '1', '13683599324', NULL, '120101', '[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":120,\"height\":68,\"location\":\"http://tmp/bVPLAOjYazdNacdf5d68edfa466f751d06c612accfff.jpg\"},\"name\":\"bVPLAOjYazdNacdf5d68edfa466f751d06c612accfff.jpg\",\"path\":\"http://tmp/bVPLAOjYazdNacdf5d68edfa466f751d06c612accfff.jpg\",\"size\":2589,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/1f2f9c40-fee6-4950-8f45-b8c9fd166e1e.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/1f2f9c40-fee6-4950-8f45-b8c9fd166e1e.jpg\"}]', '2022-11-27 15:46:15', NULL, NULL, NULL, NULL, '3', '[[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":1280,\"height\":1706,\"location\":\"http://tmp/Se6xMmhOsBYk7f2a7b26be07ed6239fbefe4250162a9.jpg\"},\"name\":\"Se6xMmhOsBYk7f2a7b26be07ed6239fbefe4250162a9.jpg\",\"path\":\"http://tmp/Se6xMmhOsBYk7f2a7b26be07ed6239fbefe4250162a9.jpg\",\"size\":141145,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/df05f49d-aad0-4561-b7a9-67194a66f00e.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/df05f49d-aad0-4561-b7a9-67194a66f00e.jpg\"}],[{\"extname\":\"jpg\",\"fileType\":\"image\",\"image\":{\"width\":180,\"height\":240,\"location\":\"http://tmp/5c4QsPzixNAld0d0ac1e66a923705d609e51d15b7597.jpg\"},\"name\":\"5c4QsPzixNAld0d0ac1e66a923705d609e51d15b7597.jpg\",\"path\":\"http://tmp/5c4QsPzixNAld0d0ac1e66a923705d609e51d15b7597.jpg\",\"size\":9346,\"fileID\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/22e37e4c-6453-4764-9809-7ec04debb128.jpg\",\"url\":\"https://vkceyugu.cdn.bspapp.com/VKCEYUGU-02875484-7270-4d81-8cc4-5b5dc63c384e/22e37e4c-6453-4764-9809-7ec04debb128.jpg\"}]]', '无', NULL, '1', 'b4ishm-er8lm', 'mn4ted-xjc8sp', '刘于', '无', 0, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for view_authority
-- ----------------------------
DROP TABLE IF EXISTS `view_authority`;
CREATE TABLE `view_authority` (
  `view_authority_id` int NOT NULL AUTO_INCREMENT,
  `view_authority_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `view_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`view_authority_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of view_authority
-- ----------------------------
BEGIN;
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (1, '系统首页', 'Home');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (2, '专业管理', 'EducationalMajors');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (3, '专业详情', 'EducationalMajorsDetail');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (4, '题库管理', 'Questions');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (5, '教室管理', 'AcademicRoom');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (6, '组织架构', 'EnterpriseArchitectures');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (7, '班级管理', 'AcademicClass');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (8, '学生管理', 'EducationalStudent');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (9, '班级详情', 'AcademicClassDetail');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (10, '试卷管理', 'EducationalPaper');
INSERT INTO `view_authority` (`view_authority_id`, `view_authority_text`, `view_id`) VALUES (11, '创建试卷', 'EducationalPaperCreate');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
